// dao/userSqlMapping.js
// CRUD SQL语句
var user = {
	// insert:'INSERT INTO testuser(time,name,company,tel,email) VALUES(?,?,?,?,?)',
	/*update:'update users set name=?, age=? where id=?',*/
	insert:'INSERT INTO user(name,password,email,regtime,lastlogintime) VALUES(?,?,?,?,?)',
	update:'update user set logo=? where id=?',
	delete: 'delete from user where id=?',
	login: 'select * from user where name=? and password=?',
	queryById: 'select * from user where id=?',
	queryByName: 'select * from user where name=?',
	queryAll: 'select * from user'
};
 
module.exports = user;